Integrate with SSO and SIS providers.

What is SSO and why is it used?

Single Sign-On (SSO) allows you to use your Google, Microsoft, or Clever profile to authenticate you when logging into Formative. If your school account is tied to one of these providers, we encourage you to use SSO for efficiency.

If you don't use one of those providers, you can create a password for your Formative login. Students and teachers can use either method.

With Formative you can sync rosters with your Student Information System (SIS).

Syncing rosters with your SIS is one way to set up all teacher and student accounts and to automatically place all students and teachers into their classes.

Step 1: Check if you have software that supports OneRoster

In order to set up a OneRoster connection, you will need an SIS or other software system component that allows access to rosters using OneRoster 1.1 API or CSV files. Aeries, ClassLink, PowerSchool Unified, and Infinite Campus are some examples of software that support OneRoster exports using the API integration method.

Some of our customers do not have any system that supports OneRoster. In this case, some have adopted ClassLink, which can be used to add OneRoster support to a variety of SIS systems (read more about that here). A few others have implemented a custom software solution on their end to generate OneRoster files and then upload them to an SFTP server.

Once you have identified a way to provide us with OneRoster data, you will have to consult its documentation (assuming it is not a custom solution) to determine how to set up a OneRoster export and provide us with the necessary information to access it.

Step 2: Get OneRoster Sync Credentials Or Set up OneRoster SFTP Uploads

For OneRoster API integrations, you are given a OneRoster Base URL, Consumer Key, and Consumer Secret.

Blackbaud users: your base URL is based on your Blackbaud access URL. If your Blackbaud domain name is yourschool.myschoolapp.com, then your Base URL will be https://yourschool.myschoolapp.com/ims/oneroster/v1p1

You can encrypt the consumer secret into a secure sharing URL using https://dead-drop.me. Send the Base URL, Consumer Key, and Consumer Secret to your implementation specialist.

Note: if you are using ClassLink, you can instruct members to share roster data with us instead of sending us the credentials. Check out this article for more details.

If your system does not support OneRoster API integration but exports CSV files that must be added to a ZIP file and uploaded to an SFTP site, please contact us to set up an SFTP account you can use to upload the file.

We only need these files for rostering from zipped CSV files:

• academicSessions.csv
• classes.csv
• enrollments.csv
• orgs.csv
• users.csv

You can optionally provide courses.csv.

Step 3: Establish scope of the import

In addition to the OneRoster access information, we will want to know which organizations (schools, districts, departments, etc.) you wish to import to help us validate the data we receive; this information also helps avoid importing the wrong users. We will want to know the NCES ID (or other government ID, if available) of each school and district, too, so we can avoid data duplication.

Since your organization will have some degree of control over the users that OneRoster imports, we restrict the imported users to a list of emails and email address domains that we can confirm you control. We will need to know all the email domains that your district owns to enable the import of those users via OneRoster. If you have a subset of users outside your controlled email domain (contractors, for example), we can also accommodate a small number of specific, individual email addresses.

Step 4: Make sure we have the information we need for the import

After doing all of the above, be prepared to provide us with the following information if you haven't already done so:

• If API sync is supported: OneRoster API consumer key, secret, and Base URL (do not send these if data is shared using ClassLink)
• List of organizations to roster
• If applicable, NCES / government identifiers for each organization
• Email domains of the users to import
• When to start the import (if not immediately)

Additional Notes

• Existing Classes: Classes imported from OneRoster do not link or merge with existing classes, so you will have to decide what to do with duplicate classes for teachers who have already set up their classes. It is easiest for teachers to keep existing classes and archive the OneRoster-created classes when they get duplicates. The downside of this process: those classes will not automatically update from the SIS, but existing assignments to the class will not have to be copied to the new class.
• Teacher Login: Teachers will receive emails with some information about their new account, including how to set their password if they need instructions. If they use SSO logins (Google, Clever, Canvas, Microsoft, LTI, etc.), they won't need to create a password.
• Student Login: If students cannot use a SSO login, teachers can set their passwords via the classes page. Students with access to their email can also use the "forgot password" feature to set their password. We also offer the option of setting each student's password to their "identifier" (e.g. Student ID) by default, although doing so is not the most secure approach.
• Administrator Users: Although we normally only set up students and teachers using OneRoster, we can use it to control Formative administrators. If you provide us with a list of the members you believe should be formative administrators, we can check whether that information matches OneRoster user data and then update OneRoster in addition to students and teachers. If this information does not match, then Formative administrator access will have to be managed manually.‍
• Class Start & End Dates: If OneRoster data includes start and end dates for classes, then classes will not be created if they are more than fourteen days away. Classes created in the past that are more than fourteen days old will be marked as archived.

The following platforms provide a OneRoster API that is known to work with Formative:

• Aeries
• Blackbaud
• ClassLink
• Focus School Software
• Infinite Campus

‍

Monitor student growth against standards over time.

To access the student growth tracker, click on the Tracker tab at the top of your dashboard.

1. Switch between viewing scores by Formatives or by tagged Standards.
2. This area will display any filters that are currently defined. Click the pencil icon next to each of these to adjust your filter's range, or you can remove them.
3. Here you will find the display area for class scores.
4. Toggle this button to hide student names.
5. Click the "Filter" button to define your view range by adjusting the date last answered, classes, grade levels, subjects, and Formative types. Each of the filters chosen will then appear in the area marked 2.
6. Click the "Sort by" button, and sort if students will appear by their names or by their scores. You can also sort formatives by their title or by date answered.
7. Click the "Export" button to export data as a CSV/Spreadsheet or asa Google Sheet (see the following for more details).

More ways to view the tracker:

When showing Formatives (at the top left), click on individual student names to view their overall score for each assignment.

Note: Students who have not yet taken a formative will have a blank score in the Tracker.‍

Select "Standards" to see how students performed against standards tagged in the assignments. To do so, click on "Standards," expand the standards to see them in detail (if you want), and click the student's name.

The Student Growth Tracker measures student progress over time, so it is helpful to understand how the scores are calculated.

To calculate scores, we sum up all the points that answers received (=points earned). We then total all points available for those answers (the point value on the questions = points possible) and divide the former by the latter.

For example, let's say a student completes one formative with two questions. Question one is worth five points. Question two is worth ten points. The student gets two points on the first question and six points on the second. Their score for that formative is as follows: (2 + 6)/(5 + 10) = 8/15 = 53%.

When calculating multiple formatives, we consider all questions and basically treat them as if they were one big formative. For example, let's add a formative to our previous example. This formative has one question worth five points, and the student earned four points. This student's overall grade is now as follows: (2 + 6 + 4)/(5 + 10 + 5) = 12/20 = 60%

As a result, the system will weigh a formative or question with more available points more heavily in the overall score.

NOTE: If a student did not submit an assignment, unanswered questions do not count toward possible points. When students submit an assignment with an unanswered question, their work will count towards the total possible points, thus reducing the overall score. Read about how to force-submit a formative here.

If at a later time, a teacher adds a new question that students do not answer, the tracker will not count the points for that question in their score.

Export data from the Tracker

From the Tracker page, you can select the Export button located in the top right corner.

Once you select that button, a pop-up screen will appear for you to choose the content you’d like to export. You can export as a CSV/spreadsheet or as a Google Sheet. You can also export all rows or only the rows you have expanded.

When selecting Download as CSV/Spreadsheet, it will download directly to your computer.

If you select Google Sheets, the platform will direct you to choose the email associated with your account. You will then receive a prompt to your Google Sheets page.